SELECT a.t_id, a.t_codice, a.t_nome, a.t_outlet, a.t_sconto_outlet, a.t_larghezza, a.t_lunghezza, a.t_prezzo, a.t_prezzodef, a.t_url, c.nomeITA AS nomecategoria FROM tappeti AS a, categoria AS b, categoria AS c, tappeti_categorie AS d, provenienze AS e WHERE d.tappeto = a.t_id AND d.categoria = b.id AND b.parent = c.id AND a.t_provenienza = e.p_id AND (a.t_stanze LIKE '%,6,%' OR a.t_stanze LIKE '%6,%') AND t_stato!=2 AND t_stato!=5 AND t_stato!=3 AND (t_status=1) AND ( (d.categoria != 41) AND (d.categoria != 42) AND (d.categoria != 45) AND (d.categoria != 56) ) ORDER BY t_id DESC LIMIT 0,11
Tappeti Moderni per Divani in Salotto | Morandi Tappeti
0 0
SHIRAZ
Morandi Tappeti In stock
SHIRAZ
cod. 9955
cm 166 x 287

1.500

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9952
cm 150 x 390

3.500

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9951
cm 105 x 236

1.900

PAKHISTAN
Morandi Tappeti In stock
PAKHISTAN
cod. 9968
cm 249 x 290

500

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9988
cm 164 x 316

2.500

TABRIZ
Morandi Tappeti In stock
TABRIZ
cod. 9969
cm 228 x 322

500

KIRMAN RAVER
Morandi Tappeti In stock
KIRMAN RAVER
cod. 9961
cm 285 x 490

25.000

AGRA
Morandi Tappeti In stock
AGRA
cod. 9939
cm 129 x 207

1.900

KAZAK LORI PAMPAK
Morandi Tappeti In stock
KAZAK LORI PAMPAK
cod. 9944
cm 144 x 246

2.500

KAZAK
Morandi Tappeti In stock
KAZAK
cod. 9942
cm 118 x 210

1.500

DAGHESTAN
Morandi Tappeti In stock
DAGHESTAN
cod. 9931
cm 117 x 228

950

KILIM AFGAN
Morandi Tappeti In stock
KILIM AFGAN
cod. 9769
cm 101 x 162

160